Executive Summary - Raleigh, NC Police Incidents from 2014 to 2020 4

Here is an executive summary of how your project would look like:





Troubles that occurred during the project:


1.    Finding the right KPIs.  Due to the number of columns and the amount of data available, I had to strategically select the correct KPIs that would give a clear picture to Raleigh’s Police Incidents. I finally selected the following KPIs

Violent Crime Rate
Major Crime Rate
Year over Year (YOY) Violent Crime Rate
Year over Year (YOY) Major Crime Rate



2.    Determining what a violent crime was and what a major crime was.  There are about 127 crime codes, and in order to have the correct data, I had to find out what crime codes were for violent crimes and major crimes.

Violent Crime
In the FBI’s Uniform Crime Reporting (UCR) Program, violent crime is composed of four offenses that involve force or threat of force: murder and non-negligent manslaughter, rape, robbery, and aggravated assault. Violent crimes are defined in the UCR Program as those offenses that involve force or threat of force. 

Murder - The willful (non-negligent) killing of one human being by another. Murder offenses does not include deaths caused by negligence, suicide, or accident; justifiable homicides; and attempts to murder or assaults to murder, which are classified as aggravated assaults.
Forcible Rape - The carnal knowledge of a female forcibly and against her will. Assaults or attempts to commit rape by force are also included,  however, statutory rape and incest are excluded
Robbery - The taking or attempting to take anything of value from the care, custody, or control of a person or persons by force or threat of force or violence, and/or by putting the victim in fear.
Aggravated Assault - An unlawful attack by one person upon another for the purpose of inflicting severe bodily injury.


Major Crime
Major Crimes include property crimes, person crimes, and society crimes.

Crimes Against Property - Crimes  against property are offenses of burglary, larceny, motor vehicle theft and arson.  The object of these of offenses is the taking of money or property, but there is no force or threat of force.
Crimes Against Persons - Crimes against persons are those whose victims are  individuals.
Crimes Against Society - Crimes against society represent society's prohibition against engaging in certain types of activity; they are typically victimless crimes in which property is not the object.




3.    Accurate measures.  It took me a while to get the measures to work as desired.  For example, I did not have a shooting column.  Thus, I had to create a DAX measure to calculate a shooting crime based on the crime code.  Also, in order to display correct data, I had to make sure that my DAX formulas were correct.






To find out more about Executive insights, check out one of Microsoft's partners, Decisive Data:


Decisive Data - Executive Insights